package com.springboot.demo.mapper;

import com.springboot.demo.entity.FineMsg;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface FineManageMapper {
    @Select("select * from finerecord where state='unpaid'")
    List<FineMsg> getFineMsg();

    @Update("update finerecord set state='paid' where phone=#{phone} and fine=#{fine} and initdate=#{initdate} and ID=#{bookid}" )
    void updatefine(String phone,int fine,String initdate,long bookid);
}
